create table my_salary
(
    empno		int not null,
    update_ts   datetime not null,
    salary		numeric(12,2) not null,
    primary key(empno)
) engine=innodb;

begin;
insert into my_salary values(1,sysdate(),3500.50);
insert into my_salary values(2,sysdate(),4500.50);
insert into my_salary values(3,sysdate(),4500.00);
insert into my_salary values(4,sysdate(),5500.00);
insert into my_salary values(5,sysdate(),6500.00);
insert into my_salary values(6,sysdate(),6570.00);
insert into my_salary values(7,sysdate(),7500.00);
insert into my_salary values(8,sysdate(),10500.00);
insert into my_salary values(9,sysdate(),8500.00);
insert into my_salary values(10,sysdate(),2500.50);
commit;
